/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package kn.mx.cstf2.sql;

/**
 *
 * @author user1
 */
public class LoginSQL {
    
    public static final String SELECCIONAR;
    
    public static final String TABLE_NAME = "t_users";
    public static final String ID_USUARIO = "username";
    public static final String PASSWORD = "pwd";
    public static final String TIPO = "tipo";
    private static final String EOL = " \n";
    private static final String EOL_ = ", \n";
    private static final String TAB = "\t";
    private static final String SET = " = ?";
    private static final String SET_INSERT = " ?, ";
    
    
        static {
        StringBuilder qryBuilder = new StringBuilder();
        qryBuilder.append("SELECT * FROM t_users WHERE UPPER(username) = :name AND pwd = :password");
        SELECCIONAR = qryBuilder.toString();
    }
    
        static {
            StringBuilder qryBuilder = new StringBuilder();
            qryBuilder.append("INSERT INTO t_users(id,username,pwd,email,usertype) ");
            qryBuilder.append("VALUES('STK','STK','stk@gmail.com','SU'); ");
        }
}
